Calculated Variables and Available Fields on Production Reports

Additional fields available to Job Reporting reports Job Cost Detail Job Cost Summary Job Detail Job Summary Production Costs Production Detail QC Detail Shop Schedule Work Center Capacity

DEACOM reports contain calculated fields that provide users with additional information including sums or totals based on information that may not generally be available to the report themselves. Calculated fields are also responsible for the back-end data computations on displayed production fields. The list below contains the most commonly used calculated fields for production.

Report	Field	Calculation/Definition
Production Costs	Actual Labor	Sum of Actual Labor tracked for the grouping.
	Actual Burden	Sum of Actual Burden tracked for the grouping.
	Total Standard Burden	Sum of standard burden for all parts on jobs within the grouping.
	Total Standard Labor	Sum of standard labor for all Parts on Jobs within the grouping. This field "Total Std Labor" is called total because time is not tracked against an individual Part, which is where standard labor and burden resides.
Production Detail	Actual Total (acttot)	Unit cost of the materials that were relieved to produce the item X Quantity produced
	Stand Total (stantot)	Acct. std. total from the Item master at the time the item was produced X Quantity produced
	Total Sell (totsell)	(List sales price from the item master or Price from sales order line if linked to an order) X Quantity produced
Job Cost Detail	Allcosts	The extended actual cost of materials, labor and burden used.
	Burcost	The extended actual burden cost (as defined in routings).
	Cost	The actual cost of materials, labor and burden used per stock unit. Totcost / (finished quantity or catch weight)
	Costdate	Earliest date at which a completion occurred for this job line.
	Finburcost	The extended actual finishing burden cost (as defined in routing sequences marked "finishing").
	Finlabcost	The extended actual finishing labor cost (as defined in routing sequences marked "finishing").
	Fixbur	The extended accounting standard burden cost.
	Fixfrt	The extended accounting standard freight cost.
	Fixlab	The extended accounting standard labor cost.
	Fixmat	The extended accounting standard material cost.
	Fixmbur	The extended accounting standard material burden cost.
	Indentbur	Shows the total burden for the produced lots as well as all consumed lots (proportional to use) on the job. This field is only calculated if it is actually in-use on the report. Specifically, the field will sum the burden from the dtjob4 table.
	Indentlab	Shows the total labor for the produced lots as well as all consumed lots (proportional to use) on the job. This field is only calculated if it is actually in-use on the report. Specifically, the field will sum the labor from the dtjob4 table.
	Labcost	The extended actual labor cost (as defined in routings).
	Machcost	The extended actual work center cost.
	Matcost	The total cost of actual material used.
	Purcost	The extended actual purchase cost.
	Stanbur	Accounting standard burden cost in pricing UOM. fixbur * (conversion factor from stock to pricing units)
	Stanfrt	Accounting standard freight cost in pricing UOM. fixfrt * (conversion factor from stock to pricing units)
	Stanlab	Accounting standard labor cost in pricing UOM. fixlab * (conversion factor from stock to pricing units)
	Stanmat	Extended accounting standard material cost in pricing UOM. fixmat * (conversion factor from stock to pricing units). Note that the j4_quant (quantity finished) field is used in the calculation of the Stanmat variable as long as it does not equal 0, in which case lj_quant (quantity specified on the job line) will be used.
	Stanmbur	Accounting standard material burden cost in pricing UOM. fixmbur * (conversion factor from stock to pricing units)
	Stantot	Accounting standard cost in pricing UOM. (fixmat + fixlab + fixbur + fixmbur + fixfrt) * (conversion factor from stock to pricing units)
	Totcost	The extended actual cost of materials, labor and burden used converted to pricing UOM. allcosts * (conversion factor from stock to pricing units)
	Totfin	Number of finishes for this job line.
	Totstan	The extended item master current total cost.
	Totwgt	Total finished catch weight.
	Variance	Cost - (pr_fixstan x j4_quant/prfact). Note:Cost is defined as: SUM(j4_unitcost * j4_quant) and Prfact is the conversion factor between the stock unit and the pricing unit.
Job Detail	Indentbur	Shows the total burden for the produced lots as well as all consumed lots (proportional to use) on the job. This field is only calculated if it is actually in-use on the report. Specifically, the field will sum the burden from the dtjob4 table.
	Indentlab	Shows the total labor for the produced lots as well as all consumed lots (proportional to use) on the job. This field is only calculated if it is actually in-use on the report. Specifically, the field will sum the labor from the dtjob4 table.
	lj_planquant	The planned quantity that is expected to be produced on this job. When a job line is originally added to the job, the planned quantity will match the value in the "Quantity" or lj_quant field. If a user modifies the job line and changes the lj_quant field, the planned quantity (lj_planquant) field will be changed to match this new value. Note that the planned quantity will not be changed as a result of job finishing or job closing. In this way, the system keeps a record of the planned output. In addition to the Job Detail report, the View Detail (Job), Job Entry and Close Job form grids also have access to this field.
Job Cost Summary	Acthours	Sum of modified hours worked and modified overtime hours for the job.
	Allcosts	Purchase cost + labor cost + burden cost + work center costs + cost of issued items + cost of relieved quantity - total cost of negative inventory
	Burcost	SUM of ((dmop.op_burden   dmworker.wo_burden) * j3_hours), grouped by job number
	Burcostop	SUM of ((dmop.op_burden) * j3_hours), grouped by job number
	Burcostworker	SUM of ((dmworker.wo_burden) * j3_hours), grouped by job number
	Labcost	Sum of the labor costs for the job.
	Machcost	Sum of the work center costs for the job.
	Matcost	Sum of the material costs for the job.
	Purcost	Sum of the purchase costs for the job.
	Stanbur	Sum of burden costs for the job.
	Stanburop	SUM of (dmop.op_burden) * (If j4_quant = 0 -- return 0 If j2_batch = TRUE -- (j2_hours) If j2_batch = FALSE AND j2_pieces <> 0 -- ((j4_quant * j2_hours) / j2_pieces) If j2_pieces = 0 -- return 0) Group by Job Number
	Stanhours	Planned hours divided by pieces from routings on the job.
	Stanlab	Sum of accounting labor costs for the job.
	Stanmat	Sum of accounting material costs for the job. Note that the j4_quant (quantity finished) field is used in the calculation of the Stanmat variable as long as it does not equal 0, in which case lj_quant (quantity specified on the job line) will be used.
	Stantot	stanmat + stanlab + stanbur for the job
Job Material Cost Detail	Stanmat	Extended accounting standard material cost in pricing UOM. fixmat * (conversion factor from stock to pricing units). Note that the j4_quant (quantity finished) field is used in the calculation of the Stanmat variable as long as it does not equal 0, in which case lj_quant (quantity specified on the job line) will be used.
WIP Detail	Stanmat	Extended accounting standard material cost in pricing UOM. fixmat * (conversion factor from stock to pricing units). Note that the j4_quant (quantity finished) field is used in the calculation of the Stanmat variable as long as it does not equal 0, in which case lj_quant (quantity specified on the job line) will be used.
WIP Summary	Stanmat	Sum of accounting material costs for the job. Note that the j4_quant (quantity finished) field is used in the calculation of the Stanmat variable as long as it does not equal 0, in which case lj_quant (quantity specified on the job line) will be used.

Additional fields available to Job Reporting reports

Job Cost Detail

• Actual Burden (burcost)
• Standard Burden (stanbur)
• Current Materials (pr_stanmat)
• Current Labor (pr_stanlab)
• Current Burden (pr_burden)
• Current Mat. Burd. (pr_matbur)
• Current Freight (pr_stanfrt)
• Current Total (pr_stantot)
• Indentlab
• Indentbur

Job Cost Summary

• BurCost
• BurCostOp
• BurCostWorker
• StanBurOp

Job Detail

• Work center description (ce_descrip) and maintenance task name (cm_name) fields to help with MRO reporting.
• indentlab and indentbur.
• Basefactor variable, which is the un_factor for the part's stock unit. A line for a part whose stock unit is a case of 25 will have a basefactor of 25.
• q5_approvedby field (form the dtqc5) table. This variable will indicate the user name of the user that approved QC results, which may be different then the user who entered results.
• pr_jobinc (Job Incremental Quantity) field. When jobs are created for multiple batches, Deacom does not split these batches into separate lines. Therefore, users cannot see how many batches are needed to complete a job, instead they see a lump amount in the form of job quantity. There is the ability to split jobs by job quantity, but this would produce multiple lots, which may result in separate QC testing per lot. One option to assist users when determining the batch size on jobs is having the "pr_jobinc" (Job Incremental Quantity) field visible since it is often used by batch manufactures to define batch sizes. The "pr_jobinc" field is also available to the Job Entry grid and the Job Staging Picklist printout.
• The total relieved weight available, via the "relwgt" field.
• The container size, if present, represented by the "containerSize" field .

Job Summary

• The work center from the first line item's first routing sequence is available to display. The new field name is ce_name. The basefactor variable is available to this report as well. Basefactor is the un_factor for the part's stock unit. A line for a part whose stock unit is a case of 25 will have a basefactor of 25. T
• The q5_approvedby field (form the dtqc5) table is available to this report. This variable will indicate the user name of the user that approved QC results, which may be different then the user who entered results.
• When a job pick list is printed, the time and date are now recorded and can be added to the Job Summary report.

Production Costs

• pr_codenum
• pr_descrip

Production Detail

• The job completions table (dtjob4) in DEACOM contains a field called j4_recdate. This field stores the date and time that a job completion was performed, even when performing completions for non-stock parts.

QC Detail

• Stability testing information, such as the expected stability test date, job completion date, and stability days may also be added in this report.
• QC results entered against maintenance jobs will be displayed, with the following fields available to the report: q4_date, q4_time, q4_notes, ql_approved and ql_failed from dtqclots.
• All fields from the dtfifo (inventory transactions-in) table.

Shop Schedule

• To display the total weight of issued items, the "totwgt" field may be added to the grid layout.
• Planned shop areas (planshophrs).
• Changes to job routing sequences, including dates.
• Item master user fields (dmprod fields) are available as optional fields to the shop schedule report. These fields are not required and can be added through grid layout for jobstat.

Work Center Capacity

• Available - When added to the grid, the grid will show this column once per bucket in the forecast. Shows the total available work center hours.
• Used - When added to the grid, the grid will show this column once per bucket in the forecast. Shows the used work center hours.
• Percentage - When added to the grid, the grid will show this column once per bucket in the forecast. Is used/available as a percentage, which shows capacity.